I am working on getting Drupal 10 / CiviCRM working on Pantheon.io. I am close to get CiviCRM properly running but have run into an issue where event registration creates unknown database error on test and live (but works on dev).
Steps to Setup CiviCRM on Pantheon and Reproduce Error
- Create Pantheon.io site, spin up and install Drupal 10 as usual
- Copy locally with git or “terminus local:clone SITENAME”
- In cloned folder Run “composer require civicrm/civicrm-{core,packages,drupal-8}” then “composer require civicrm/cli-tools”
- Edit the json to whitelist compiling. Under ““enable-patching”: true” add the line ““compile-whitelist”: [“civicrm/civicrm-core”, “civicrm/composer-compile-lib”]”
- Push your changes with “git add .” then “git commit -m ‘adding civicrm’” and “git push”
- Change the Pantheon Development site to SFTP
- On Pantheon site go to YOURDOMAIN.COM/admin/modules and enable “CiviCRM Core”. It will create the settings.civicrm.php file. Check to make sure it worked. (At this point it only works on the dev instance)
- Commit that file to Git on Pantheon.
- Pull down the code “git pull” to your local.
- Run "wget -O pantheon.civicrm.settings.local.php https://gist.github.com/herbdool/baec130982e3995b5577008f1a63ebd9" (see: https://www.drupal.org/project/civicrm_starterkit/issues/3095528)
- Follow instructions in pantheon.civicrm.settings.local.php to update keys and insert code in civicrm.settings.php
- Push code to pantheon (test by creating a CIVICRM event and registering on dev site, it works)
- Clone to test environment (test by creating event and registering on test site, it results in DB error)
This is when the browser, in a yellow box, displays " Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred. DB Error: unknown error"
Has anyone had success installing CiviCRM with Drupal 10 on Pantheon or encountered a similar ‘DB Error: unknown error’ during CiviCRM event registration in Drupal 10 on Pantheon?
The fact that the registration works on the dev environment but fails on the test environment, suggests a possible configuration or environmental issue. I have been trying to figure out if this can be resolved by changes to the civicrm.settings.php configuration file without luck. Any suggestions for troubleshooting or resolving this issue would be greatly appreciated.
Also posted at: https://civicrm.stackexchange.com/questions/46182/drupal-10-pantheon-io-db-error-unknown-error-on-event-registration-in-test-or
